UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NnFNPLk/S9A3LVhi7W6Z1hp7l9ubcaOzZAEuS2N6LUc='
WHERE
key_id = 'a73f0a2a32bce68a613505e5ac7892e27853422f4552e55835c5cb0e09eff301'
AND (
token = 'NnFNPLk/S9A3LVhi7W6Z1hp7l9ubcaOzZAEuS2N6LUc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)