UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'G5q2oD1AkQJ3rJPDvnDHKKIZP0pnMSkQfGNG4PwCXFU='
WHERE
key_id = '1ade79e9e4f154045a07376efe64e0a65f2ea39f7a50e25c5f934b3485ef473e'
AND (
token = 'G5q2oD1AkQJ3rJPDvnDHKKIZP0pnMSkQfGNG4PwCXFU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)