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