UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qlcjZlPhheUScasam346dIqmgxnF7KaiU6cTdUZygeM='
WHERE
key_id = '596859fd66fea04740b3e5fbd1ed9c14c3e6a9a96f63af9dfbd699f5c8ab346f'
AND (
token = 'qlcjZlPhheUScasam346dIqmgxnF7KaiU6cTdUZygeM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)