UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ASiAhOdaN6Vfdobt6XVlFMFy2XX1jo4aw4J78J6dDgE='
WHERE
key_id = '55c8e989af77a83f54239692b8d8b5a598a65f8ad96be663e527d396f94ec162'
AND (
token = 'ASiAhOdaN6Vfdobt6XVlFMFy2XX1jo4aw4J78J6dDgE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)