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