UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7Th8l+welq3kNQY55jLAV+F8qSeDl7VrwA4ndxKW+xE='
WHERE
key_id = 'c3f8540f1a5d5e3a8b14dd18255f7033487832ca83d68cef87815d81ce587a22'
AND (
token = '7Th8l+welq3kNQY55jLAV+F8qSeDl7VrwA4ndxKW+xE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)