UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WAo1XY9Mb2gCRrEi64FBevd+UlmrtYlWAfS5/3CzhpU='
WHERE
key_id = 'c373d265a75b1e1d4faf087417fb19dd2d5ed27ac7f141f56f2123c79022832e'
AND (
token = 'WAo1XY9Mb2gCRrEi64FBevd+UlmrtYlWAfS5/3CzhpU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)