UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9Ng04m/76EpjzYt/I1+W4qUoI5hu0tyW0UAl3M0059Q='
WHERE
key_id = '2e5d5c0d9c50714d4a6dfd4a0c212d59eaddb6f8f7c57019dd77b18ab56a4f0f'
AND (
token = '9Ng04m/76EpjzYt/I1+W4qUoI5hu0tyW0UAl3M0059Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)