UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gR8C5X3sLaVdM83Nk8LcH+9URRYdmFv2zWPOlDIw9To='
WHERE
key_id = '66a37a7e1dd7bf4d0e5299bbaf318ad1f18085a52574d580e15a97397a86c15a'
AND (
token = 'gR8C5X3sLaVdM83Nk8LcH+9URRYdmFv2zWPOlDIw9To='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)