UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BQ/PiETcKPsLPK9L9BzaXFzq73K0NkB5MjGtOdvsps4='
WHERE
key_id = '32a64c96bd16fe6936c1b36e867aa73ec10fd032ee5eba06964d69a115d2b6ca'
AND (
token = 'BQ/PiETcKPsLPK9L9BzaXFzq73K0NkB5MjGtOdvsps4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)