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