UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xB7ecMc6ATt8MsXPR2k7z4s6soR2lsZtJPjVWsd46DM='
WHERE
key_id = '2ecac04f22f93f9fc4989c2b37b70017610dc1a18859c15f084f456561bd3a6f'
AND (
token = 'xB7ecMc6ATt8MsXPR2k7z4s6soR2lsZtJPjVWsd46DM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)