UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XzqyoaebBkiNs7ucZLtgCa3tvmvqHEh6nxGa22ZJqZo='
WHERE
key_id = '7ad6fe92a740ded0ba65b1cf9dd409f703ed79a1d43388f86013b7b3383adfb5'
AND (
token = 'XzqyoaebBkiNs7ucZLtgCa3tvmvqHEh6nxGa22ZJqZo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)