UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '818WuXRslspcXgDUba2FkWRc4CLD+hhI6EYZBdEO8lY='
WHERE
key_id = '7d88f1043cd01e0c030c597fe7bdbb8ce29abdd47106d3bbcfd0c5df1031903b'
AND (
token = '818WuXRslspcXgDUba2FkWRc4CLD+hhI6EYZBdEO8lY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)