UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8uz57JVYzkWADtuteaJOYFlIxkvjtk5k+azq+uOQS3E='
WHERE
key_id = '1fe49b2018284f31587ff5d198e8df09bf870b52abb6359128e548c50c216a20'
AND (
token = '8uz57JVYzkWADtuteaJOYFlIxkvjtk5k+azq+uOQS3E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)