UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'chbj8Gok5Tt8hdQF72cYotFKFOX+86yGcun64LlRNoY='
WHERE
key_id = 'ca661b5f75b83bdb60893c866f037731c6cdaf3e31903ad55c7a7bdfdb708131'
AND (
token = 'chbj8Gok5Tt8hdQF72cYotFKFOX+86yGcun64LlRNoY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)