UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'R9LlPVB1ddkGAEO/Erz5tNfgwOWy838fzZK++1FJuWU='
WHERE
key_id = 'a03536498d7b9e84fe99c2028b1527a4ec82edb06e9969abd9210668909e023f'
AND (
token = 'R9LlPVB1ddkGAEO/Erz5tNfgwOWy838fzZK++1FJuWU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)