UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QDCA4zWFG0BqYle6hGUReloNO5riiaC5rkfhNfkevhU='
WHERE
key_id = 'db578377d7278374d57c99ba777ba01342855857d53c00de22984a4a04aa37be'
AND (
token = 'QDCA4zWFG0BqYle6hGUReloNO5riiaC5rkfhNfkevhU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)