UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sCTNg8Mx75YXrNrXKM5oq438Yff7VM41SDcI476BgzY='
WHERE
key_id = '24fa359a40149fc7b83c265b634cc5ace2d59b9e78043d862b8b5a49b9926cf7'
AND (
token = 'sCTNg8Mx75YXrNrXKM5oq438Yff7VM41SDcI476BgzY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)