UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Jr0J5k3aZ3CK1FGs3ZcAKtuWQl6uRCxIcIPCDTBO0HU='
WHERE
key_id = '27445a1c83325394b2c4815cb8b4ba9c798cbd34221867ed49e420f0b72bd10f'
AND (
token = 'Jr0J5k3aZ3CK1FGs3ZcAKtuWQl6uRCxIcIPCDTBO0HU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)