UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gATq2cMGVSVgX+DQDRqHmHGTPBiT0XDy7DZLVG8mRx0='
WHERE
key_id = 'ca2de167c3d27d2a8e59aa9f10393ae35c9a7435c0d781e939113fa60bc63b8f'
AND (
token = 'gATq2cMGVSVgX+DQDRqHmHGTPBiT0XDy7DZLVG8mRx0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)