UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hNqfL0g3zMdci71ijhUhGiS7526ecxvkLwKmzThkMIk='
WHERE
key_id = 'a12a9c2ad6bbd2bd5621ca285fe177bc251d0e192ada4c61ad5141031f8c923b'
AND (
token = 'hNqfL0g3zMdci71ijhUhGiS7526ecxvkLwKmzThkMIk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)