UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QiWFpXIO7tVPjrogUPOQT4sP88DK/pTZqdsGIG2b97g='
WHERE
key_id = 'b35a8b100e34d775c5e4b5fdffe6ea45255ca5fb06b71f3af8f9de8d9f8e238f'
AND (
token = 'QiWFpXIO7tVPjrogUPOQT4sP88DK/pTZqdsGIG2b97g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)