UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7KEACOME4r26eXiVp/GtSuFICMkDev5o8XUkN3OJoFc='
WHERE
key_id = '0e702ba6af6be43792ed969b5e44f63ff80d274514d68c6480d0634fa99f8a6a'
AND (
token = '7KEACOME4r26eXiVp/GtSuFICMkDev5o8XUkN3OJoFc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)