UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0gD4dpNh9txgvGXpibXjlcopMMCNwN9k146JaOgVP/U='
WHERE
key_id = 'ffda071fbc3b5b30e0c300d8175b1798c3e7777d4604821507703fd80bc7364f'
AND (
token = '0gD4dpNh9txgvGXpibXjlcopMMCNwN9k146JaOgVP/U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)