UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sMfdpGJ/ajs/d2Bh+yDweovp5A6IjfU+8IO3sXmuiiA='
WHERE
key_id = 'afe506ba44da9aa2b63a3e69784277f4cf3aac09b0c735034948dd462307ae6a'
AND (
token = 'sMfdpGJ/ajs/d2Bh+yDweovp5A6IjfU+8IO3sXmuiiA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)