UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zGa4v689YgB5cmuUIOWhNtME+lHo/+7t12owORZzcH0='
WHERE
key_id = '30254c92acf904370544dfba7aa01b4a55cef32d4e3f7a306f59cfd4c80536bd'
AND (
token = 'zGa4v689YgB5cmuUIOWhNtME+lHo/+7t12owORZzcH0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)