UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jNHhx2aGQlzDU/tCrvnqvcFMNOKW+INQJ/4Pq1HsDpo='
WHERE
key_id = '2a1e948ac8d6406c369b0896b21271e7a88cd1926a90b6727dba6efa0505a7a1'
AND (
token = 'jNHhx2aGQlzDU/tCrvnqvcFMNOKW+INQJ/4Pq1HsDpo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)