UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+Z/yJrkVPx9+qxAi5f8jw9xwoNFHDmQ4oF9nc3YaT/8='
WHERE
key_id = 'f6e39e4f4fb3b12de8f7818b27d2148687d9c8ca2fa8cd94e34734f8bb9d5342'
AND (
token = '+Z/yJrkVPx9+qxAi5f8jw9xwoNFHDmQ4oF9nc3YaT/8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)