UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'iPGl59Hyg33E7cviHUyXAqkGD1VO0EDyWHyIERD5III='
WHERE
key_id = 'afa032699bbfcf41b1f24996c68cb52b51b8ec0f696b6a2694a50b71ecbab899'
AND (
token = 'iPGl59Hyg33E7cviHUyXAqkGD1VO0EDyWHyIERD5III='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)