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