UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DiD3hQihBF8KeT1NAC6kP1D07E6/8JyIjeA7S+/p7Ls='
WHERE
key_id = 'b64b2796932ced022660437db3da4e3c76089f15f4daa770978d36a40ca59e9e'
AND (
token = 'DiD3hQihBF8KeT1NAC6kP1D07E6/8JyIjeA7S+/p7Ls='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)