UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oZi5Ve9kTYTC6iy8roUrCkmgr+oZQa757lhgFpycSjU='
WHERE
key_id = 'ead42b943a99ec10919d8c52b819ffd11ae57600fc505cc8a632a843df90c61f'
AND (
token = 'oZi5Ve9kTYTC6iy8roUrCkmgr+oZQa757lhgFpycSjU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)